Starting test 'TvpTest'
Starting Test using AsyncDebugScope
Tests using AsyncDebugScope are only supported in Debug mode!
Finished Test using AsyncDebugScope
Test immediate cancel for binary stream
PASS: Task is cancelled
Test immediate cancel for text stream
PASS: Task is cancelled
Test immediate cancel for xml stream
PASS: Task is cancelled
Test command preparation PASS
Test reuse of command after cancel
PASS
Test reuse of command after cancel
PASS
Test reuse of command after cancel
PASS
+++++++ Iteration 0 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 1 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 2 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 28
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 3 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 4 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 5 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 28
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 6 ++++++++
SqlException creating objects: 1701
SqlException dropping objects: 3701
+++++++ Iteration 7 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 28
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 8 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 28
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 9 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 10 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 11 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 28
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 12 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 13 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 14 ++++++++
SqlException creating objects: 1701
SqlException dropping objects: 3701
+++++++ Iteration 15 ++++++++
SqlException creating objects: 1701
SqlException dropping objects: 3701
+++++++ Iteration 16 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 28
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 17 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 28
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 18 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 19 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 20 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
Matches = 14
SqlException. Error Code: 8152
Matches = 28
Matches = 14
SqlException. Error Code: 8152
Matches = 14
Matches = 14
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 21 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
SqlException. Error Code: 8152
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 22 ++++++++
SqlException creating objects: 1701
SqlException dropping objects: 3701
+++++++ Iteration 23 ++++++++
SqlException creating objects: 1701
SqlException dropping objects: 3701
+++++++ Iteration 24 ++++++++
SqlException creating objects: 1701
SqlException dropping objects: 3701
+++++++ Iteration 25 ++++++++
------IEnumerable<SqlDataRecord>---------
Failed Row[0]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[1]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[4]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[5]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[8]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[9]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=0, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=1, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=4, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=5, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=8, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=9, Column=5
Matches = 162
------DbDataReader---------
Failed Row[0]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[1]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[4]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[5]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[8]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[9]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=0, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=1, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=4, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=5, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=8, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=9, Column=5
Matches = 162
------DataTables---------
SqlException. Error Code: 242
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 28
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 26 ++++++++
------IEnumerable<SqlDataRecord>---------
Matches = 168
------DbDataReader---------
Matches = 168
------DataTables---------
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 28
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
SqlException. Error Code: 8152
SqlException. Error Code: 8152
Matches = 14
+++++++ Iteration 27 ++++++++
------IEnumerable<SqlDataRecord>---------
Failed Row[0]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[1]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[1]Col[9] = -922337203685477: SqlDbType.SmallMoney overflow.  Value '-922337203685477.0000' is out of range.  Must be between -214,748.3648 and 214,748.3647.
Failed Row[2]Col[9] = 922337203685477.5807: SqlDbType.SmallMoney overflow.  Value '922337203685477.5807' is out of range.  Must be between -214,748.3648 and 214,748.3647.
Failed Row[4]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[5]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[8]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[9]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[10]Col[9] = -922337203685477: SqlDbType.SmallMoney overflow.  Value '-922337203685477.0000' is out of range.  Must be between -214,748.3648 and 214,748.3647.
Failed Row[11]Col[9] = 922337203685477.5807: SqlDbType.SmallMoney overflow.  Value '922337203685477.5807' is out of range.  Must be between -214,748.3648 and 214,748.3647.
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=0, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=1, Column=5
Mismatch: Source = -922337203685477, result = , metadata=SteAttributeKey=SmallMoney
   Row=1, Column=9
Mismatch: Source = 922337203685477.5807, result = , metadata=SteAttributeKey=SmallMoney
   Row=2, Column=9
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=4, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=5, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=8, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=9, Column=5
Mismatch: Source = -922337203685477, result = , metadata=SteAttributeKey=SmallMoney
   Row=10, Column=9
Mismatch: Source = 922337203685477.5807, result = , metadata=SteAttributeKey=SmallMoney
   Row=11, Column=9
Matches = 158
------DbDataReader---------
Failed Row[0]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[1]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[1]Col[9] = -922337203685477: SqlDbType.SmallMoney overflow.  Value '-922337203685477.0000' is out of range.  Must be between -214,748.3648 and 214,748.3647.
Failed Row[2]Col[9] = 922337203685477.5807: SqlDbType.SmallMoney overflow.  Value '922337203685477.5807' is out of range.  Must be between -214,748.3648 and 214,748.3647.
Failed Row[4]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[5]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[8]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[9]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata.
Failed Row[10]Col[9] = -922337203685477: SqlDbType.SmallMoney overflow.  Value '-922337203685477.0000' is out of range.  Must be between -214,748.3648 and 214,748.3647.
Failed Row[11]Col[9] = 922337203685477.5807: SqlDbType.SmallMoney overflow.  Value '922337203685477.5807' is out of range.  Must be between -214,748.3648 and 214,748.3647.
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=0, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=1, Column=5
Mismatch: Source = -922337203685477, result = , metadata=SteAttributeKey=SmallMoney
   Row=1, Column=9
Mismatch: Source = 922337203685477.5807, result = , metadata=SteAttributeKey=SmallMoney
   Row=2, Column=9
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=4, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=5, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=8, Column=5
Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime
   Row=9, Column=5
Mismatch: Source = -922337203685477, result = , metadata=SteAttributeKey=SmallMoney
   Row=10, Column=9
Mismatch: Source = 922337203685477.5807, result = , metadata=SteAttributeKey=SmallMoney
   Row=11, Column=9
Matches = 158
------DataTables---------
SqlException. Error Code: 242
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8152
SqlException. Error Code: 8115
------- Sort order + uniqueness #1: simple -------
-------------
0  Z-value  3/1/2000 12:00:00 AM  5  
1  X-value  1/1/2000 12:00:00 AM  7  

-------------
------- Sort order + uniqueness #2: mixed order -------
-------------
4  X-value  1/1/2000 12:00:00 AM  3  
5  X-value  3/1/2000 12:00:00 AM  3  

-------------
------- default column #1: outer subset -------
-------------
-1  Y-value  1/1/2000 12:00:00 AM  -1  
-1  Z-value  1/1/2000 12:00:00 AM  -1  

-------------
------- default column #1: middle subset -------
-------------
4  DEFUALT  1/1/2006 12:00:00 AM  3  
5  DEFUALT  1/1/2006 12:00:00 AM  3  

-------------
------- default column #1: all -------
-------------
-1  DEFUALT  1/1/2006 12:00:00 AM  -1  
-1  DEFUALT  1/1/2006 12:00:00 AM  -1  

-------------

Starting test 'SqlVariantParam'
SendVariantBulkCopy[SqlDataReader]       -> System.Data.SqlTypes.SqlSingle:real
SendVariantBulkCopy[DataTable]           -> System.Data.SqlTypes.SqlSingle:real
SendVariantBulkCopy[DataRow]             -> System.Data.SqlTypes.SqlSingle:real
SendVariantParam                         -> System.Data.SqlTypes.SqlSingle:real
SendVariantTvp[SqlMetaData]              -> System.Data.SqlTypes.SqlSingle:real
SendVariantTvp[SqlDataReader]            -> System.Data.SqlTypes.SqlSingle:real
SendVariantBulkCopy[SqlDataReader]       -> System.Data.SqlTypes.SqlSingle:real
SendVariantBulkCopy[DataTable]           -> System.Data.SqlTypes.SqlSingle:real
SendVariantBulkCopy[DataRow]             -> System.Data.SqlTypes.SqlSingle:real
SendVariantParam                         -> System.Data.SqlTypes.SqlSingle:real
SendVariantTvp[SqlMetaData]              -> System.Data.SqlTypes.SqlSingle:real
SendVariantTvp[SqlDataReader]            -> System.Data.SqlTypes.SqlSingle:real
SendVariantBulkCopy[SqlDataReader]       -> System.Data.SqlTypes.SqlString:nvarchar
SendVariantBulkCopy[DataTable]           -> System.Data.SqlTypes.SqlString:nvarchar
SendVariantBulkCopy[DataRow]             -> System.Data.SqlTypes.SqlString:nvarchar
SendVariantParam                         -> System.Data.SqlTypes.SqlString:nvarchar
SendVariantTvp[SqlMetaData]              -> System.Data.SqlTypes.SqlString:nvarchar
SendVariantTvp[SqlDataReader]            -> System.Data.SqlTypes.SqlString:nvarchar
SendVariantBulkCopy[SqlDataReader]       -> System.Data.SqlTypes.SqlDouble:float
SendVariantBulkCopy[DataTable]           -> System.Data.SqlTypes.SqlDouble:float
SendVariantBulkCopy[DataRow]             -> System.Data.SqlTypes.SqlDouble:float
SendVariantParam                         -> System.Data.SqlTypes.SqlDouble:float
SendVariantTvp[SqlMetaData]              -> System.Data.SqlTypes.SqlDouble:float
SendVariantTvp[SqlDataReader]            -> System.Data.SqlTypes.SqlDouble:float
SendVariantBulkCopy[SqlDataReader]       -> System.Data.SqlTypes.SqlBinary:varbinary
SendVariantBulkCopy[DataTable]           -> System.Data.SqlTypes.SqlBinary:varbinary
SendVariantBulkCopy[DataRow]             -> System.Data.SqlTypes.SqlBinary:varbinary
SendVariantParam                         -> System.Data.SqlTypes.SqlBinary:varbinary
SendVariantTvp[SqlMetaData]              -> System.Data.SqlTypes.SqlBinary:varbinary
SendVariantTvp[SqlDataReader]            -> System.Data.SqlTypes.SqlBinary:varbinary
SendVariantBulkCopy[SqlDataReader]       -> System.Data.SqlTypes.SqlGuid:uniqueidentifier
SendVariantBulkCopy[DataTable]           -> System.Data.SqlTypes.SqlGuid:uniqueidentifier
SendVariantBulkCopy[DataRow]             -> System.Data.SqlTypes.SqlGuid:uniqueidentifier
SendVariantParam                         -> System.Data.SqlTypes.SqlGuid:uniqueidentifier
SendVariantTvp[SqlMetaData]              -> System.Data.SqlTypes.SqlGuid:uniqueidentifier
SendVariantTvp[SqlDataReader]            -> System.Data.SqlTypes.SqlGuid:uniqueidentifier
SendVariantBulkCopy[SqlDataReader]       -> System.Data.SqlTypes.SqlBoolean:bit
SendVariantBulkCopy[DataTable]           -> System.Data.SqlTypes.SqlBoolean:bit
SendVariantBulkCopy[DataRow]             -> System.Data.SqlTypes.SqlBoolean:bit
SendVariantParam                         -> System.Data.SqlTypes.SqlBoolean:bit
SendVariantTvp[SqlMetaData]              -> System.Data.SqlTypes.SqlBoolean:bit
SendVariantTvp[SqlDataReader]            -> System.Data.SqlTypes.SqlBoolean:bit
SendVariantBulkCopy[SqlDataReader]       -> System.Data.SqlTypes.SqlBoolean:bit
SendVariantBulkCopy[DataTable]           -> System.Data.SqlTypes.SqlBoolean:bit
SendVariantBulkCopy[DataRow]             -> System.Data.SqlTypes.SqlBoolean:bit
SendVariantParam                         -> System.Data.SqlTypes.SqlBoolean:bit
SendVariantTvp[SqlMetaData]              -> System.Data.SqlTypes.SqlBoolean:bit
SendVariantTvp[SqlDataReader]            -> System.Data.SqlTypes.SqlBoolean:bit
SendVariantBulkCopy[SqlDataReader]       -> System.Data.SqlTypes.SqlByte:tinyint
SendVariantBulkCopy[DataTable]           -> System.Data.SqlTypes.SqlByte:tinyint
SendVariantBulkCopy[DataRow]             -> System.Data.SqlTypes.SqlByte:tinyint
SendVariantParam                         -> System.Data.SqlTypes.SqlByte:tinyint
SendVariantTvp[SqlMetaData]              -> System.Data.SqlTypes.SqlByte:tinyint
SendVariantTvp[SqlDataReader]            -> System.Data.SqlTypes.SqlByte:tinyint
SendVariantBulkCopy[SqlDataReader]       -> System.Data.SqlTypes.SqlInt16:smallint
SendVariantBulkCopy[DataTable]           -> System.Data.SqlTypes.SqlInt16:smallint
SendVariantBulkCopy[DataRow]             -> System.Data.SqlTypes.SqlInt16:smallint
SendVariantParam                         -> System.Data.SqlTypes.SqlInt16:smallint
SendVariantTvp[SqlMetaData]              -> System.Data.SqlTypes.SqlInt16:smallint
SendVariantTvp[SqlDataReader]            -> System.Data.SqlTypes.SqlInt16:smallint
SendVariantBulkCopy[SqlDataReader]       -> System.Data.SqlTypes.SqlInt32:int
SendVariantBulkCopy[DataTable]           -> System.Data.SqlTypes.SqlInt32:int
SendVariantBulkCopy[DataRow]             -> System.Data.SqlTypes.SqlInt32:int
SendVariantParam                         -> System.Data.SqlTypes.SqlInt32:int
SendVariantTvp[SqlMetaData]              -> System.Data.SqlTypes.SqlInt32:int
SendVariantTvp[SqlDataReader]            -> System.Data.SqlTypes.SqlInt32:int
SendVariantBulkCopy[SqlDataReader]       -> System.Data.SqlTypes.SqlInt64:bigint
SendVariantBulkCopy[DataTable]           -> System.Data.SqlTypes.SqlInt64:bigint
SendVariantBulkCopy[DataRow]             -> System.Data.SqlTypes.SqlInt64:bigint
SendVariantParam                         -> System.Data.SqlTypes.SqlInt64:bigint
SendVariantTvp[SqlMetaData]              -> System.Data.SqlTypes.SqlInt64:bigint
SendVariantTvp[SqlDataReader]            -> System.Data.SqlTypes.SqlInt64:bigint
SendVariantBulkCopy[SqlDataReader]       -> System.Data.SqlTypes.SqlDecimal:numeric
SendVariantBulkCopy[DataTable]           -> System.Data.SqlTypes.SqlDecimal:numeric
SendVariantBulkCopy[DataRow]             -> System.Data.SqlTypes.SqlDecimal:numeric
SendVariantParam                         -> System.Data.SqlTypes.SqlDecimal:numeric
SendVariantTvp[SqlMetaData]              -> System.Data.SqlTypes.SqlDecimal:numeric
SendVariantTvp[SqlDataReader]            -> System.Data.SqlTypes.SqlDecimal:numeric
SendVariantBulkCopy[SqlDataReader]       -> System.Data.SqlTypes.SqlDateTime:datetime
SendVariantBulkCopy[DataTable]           -> System.Data.SqlTypes.SqlDateTime:datetime
SendVariantBulkCopy[DataRow]             -> System.Data.SqlTypes.SqlDateTime:datetime
SendVariantParam                         -> System.Data.SqlTypes.SqlDateTime:datetime
SendVariantTvp[SqlMetaData]              -> System.Data.SqlTypes.SqlDateTime:datetime
SendVariantTvp[SqlDataReader]            -> System.Data.SqlTypes.SqlDateTime:datetime
SendVariantBulkCopy[SqlDataReader]       -> System.Data.SqlTypes.SqlDecimal:numeric
   --> ERROR: Expected type System.Data.SqlTypes.SqlMoney does not match actual type System.Data.SqlTypes.SqlDecimal
   --> ERROR: Expected base type money does not match actual base type numeric
SendVariantBulkCopy[DataTable]           -> System.Data.SqlTypes.SqlDecimal:numeric
   --> ERROR: Expected type System.Data.SqlTypes.SqlMoney does not match actual type System.Data.SqlTypes.SqlDecimal
   --> ERROR: Expected base type money does not match actual base type numeric
SendVariantBulkCopy[DataRow]             -> System.Data.SqlTypes.SqlDecimal:numeric
   --> ERROR: Expected type System.Data.SqlTypes.SqlMoney does not match actual type System.Data.SqlTypes.SqlDecimal
   --> ERROR: Expected base type money does not match actual base type numeric
SendVariantParam                         -> System.Data.SqlTypes.SqlMoney:money
SendVariantTvp[SqlMetaData]              -> System.Data.SqlTypes.SqlMoney:money
SendVariantTvp[SqlDataReader]            -> System.Data.SqlTypes.SqlMoney:money
End test 'SqlVariantParam'

------------------------------ TestSimpleParameter_Type [type: date value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ TestSimpleParameter_Variant [type: date value:1/1/0001 00:00:00] ------------------------------
TestSimpleParameter_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataRecordParameterToTVP_Type [type: date value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: date value:1/1/0001 00:00:00] ------------------------------
TestSqlDataRecordParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataReaderParameterToTVP_Type [type: date value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: date value:1/1/0001 00:00:00] ------------------------------
TestSqlDataReaderParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataReader_TVP_Type [type: date value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ TestSqlDataReader_TVP_Variant [type: date value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == date : date
Value       => Expected : Actual == 0 : 0

------------------------------ TestSimpleDataReader_Type [type: date value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ TestSimpleDataReader_Variant [type: date value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == date : date
Value       => Expected : Actual == 0 : 0

------------------------------ SqlBulkCopySqlDataReader_Type [type: date value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ SqlBulkCopySqlDataReader_Variant [type: date value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == date : date
Value       => Expected : Actual == 0 : 0

------------------------------ SqlBulkCopyDataTable_Type [type: date value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ SqlBulkCopyDataTable_Variant [type: date value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopyDataTable_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ SqlBulkCopyDataRow_Type [type: date value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ SqlBulkCopyDataRow_Variant [type: date value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopyDataRow_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSimpleParameter_Type [type: date value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378112000000000
Test Simple Parameter [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSimpleParameter_Variant [type: date value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == date : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test Simple Parameter [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = date]
Test Simple Parameter [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataRecordParameterToTVP_Type [type: date value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378112000000000
Test SqlDataRecord Parameter To TVP [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: date value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == date : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = date]
Test SqlDataRecord Parameter To TVP [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataReaderParameterToTVP_Type [type: date value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378112000000000
Test SqlDataReader Parameter To TVP [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: date value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == date : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = date]
Test SqlDataReader Parameter To TVP [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataReader_TVP_Type [type: date value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378112000000000
Test SqlDataReader TVP [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataReader_TVP_Variant [type: date value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == date : date
Value       => Expected : Actual == 3155378975999999999 : 3155378112000000000
Test SqlDataReader TVP [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSimpleDataReader_Type [type: date value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378112000000000
Test Simple Data Reader [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSimpleDataReader_Variant [type: date value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == date : date
Value       => Expected : Actual == 3155378975999999999 : 3155378112000000000
Test Simple Data Reader [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ SqlBulkCopySqlDataReader_Type [type: date value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378112000000000
SqlBulkCopy From SqlDataReader [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ SqlBulkCopySqlDataReader_Variant [type: date value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == date : date
Value       => Expected : Actual == 3155378975999999999 : 3155378112000000000
SqlBulkCopy From SqlDataReader [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ SqlBulkCopyDataTable_Type [type: date value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378112000000000
SqlBulkCopy From Data Table [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ SqlBulkCopyDataTable_Variant [type: date value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == date : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = date]
SqlBulkCopy From Data Table [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ SqlBulkCopyDataRow_Type [type: date value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378112000000000
SqlBulkCopy From Data Row [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ SqlBulkCopyDataRow_Variant [type: date value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == date : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = date]
SqlBulkCopy From Data Row [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSimpleParameter_Type [type: datetime2 value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ TestSimpleParameter_Variant [type: datetime2 value:1/1/0001 00:00:00] ------------------------------
TestSimpleParameter_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataRecordParameterToTVP_Type [type: datetime2 value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: datetime2 value:1/1/0001 00:00:00] ------------------------------
TestSqlDataRecordParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataReaderParameterToTVP_Type [type: datetime2 value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: datetime2 value:1/1/0001 00:00:00] ------------------------------
TestSqlDataReaderParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataReader_TVP_Type [type: datetime2 value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ TestSqlDataReader_TVP_Variant [type: datetime2 value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime2
Value       => Expected : Actual == 0 : 0

------------------------------ TestSimpleDataReader_Type [type: datetime2 value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ TestSimpleDataReader_Variant [type: datetime2 value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime2
Value       => Expected : Actual == 0 : 0

------------------------------ SqlBulkCopySqlDataReader_Type [type: datetime2 value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ SqlBulkCopySqlDataReader_Variant [type: datetime2 value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime2
Value       => Expected : Actual == 0 : 0

------------------------------ SqlBulkCopyDataTable_Type [type: datetime2 value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ SqlBulkCopyDataTable_Variant [type: datetime2 value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopyDataTable_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ SqlBulkCopyDataRow_Type [type: datetime2 value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ SqlBulkCopyDataRow_Variant [type: datetime2 value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopyDataRow_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSimpleParameter_Type [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ TestSimpleParameter_Variant [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test Simple Parameter [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2]
Test Simple Parameter [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataRecordParameterToTVP_Type [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2]
Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataReaderParameterToTVP_Type [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2]
Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataReader_TVP_Type [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ TestSqlDataReader_TVP_Variant [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime2
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ TestSimpleDataReader_Type [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ TestSimpleDataReader_Variant [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime2
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ SqlBulkCopySqlDataReader_Type [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ SqlBulkCopySqlDataReader_Variant [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime2
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ SqlBulkCopyDataTable_Type [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ SqlBulkCopyDataTable_Variant [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2]
SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ SqlBulkCopyDataRow_Type [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ SqlBulkCopyDataRow_Variant [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2]
SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSimpleParameter_Type [type: datetime value:1/1/0001 00:00:00] ------------------------------
TestSimpleParameter_Type[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSimpleParameter_Variant [type: datetime value:1/1/0001 00:00:00] ------------------------------
TestSimpleParameter_Variant[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataRecordParameterToTVP_Type [type: datetime value:1/1/0001 00:00:00] ------------------------------
TestSqlDataRecordParameterToTVP_Type[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: datetime value:1/1/0001 00:00:00] ------------------------------
TestSqlDataRecordParameterToTVP_Variant[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataReaderParameterToTVP_Type [type: datetime value:1/1/0001 00:00:00] ------------------------------
TestSqlDataReaderParameterToTVP_Type[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: datetime value:1/1/0001 00:00:00] ------------------------------
TestSqlDataReaderParameterToTVP_Variant[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataReader_TVP_Type [type: datetime value:1/1/0001 00:00:00] ------------------------------
TestSqlDataReader_TVP_Type[EXPECTED EXPECTION] The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
The statement has been terminated.

------------------------------ TestSqlDataReader_TVP_Variant [type: datetime value:1/1/0001 00:00:00] ------------------------------
TestSqlDataReader_TVP_Variant[EXPECTED EXPECTION] The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
The statement has been terminated.

------------------------------ TestSimpleDataReader_Type [type: datetime value:1/1/0001 00:00:00] ------------------------------
TestSimpleDataReader_Type[EXPECTED EXPECTION] The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
The statement has been terminated.

------------------------------ TestSimpleDataReader_Variant [type: datetime value:1/1/0001 00:00:00] ------------------------------
TestSimpleDataReader_Variant[EXPECTED EXPECTION] The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
The statement has been terminated.

------------------------------ SqlBulkCopySqlDataReader_Type [type: datetime value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopySqlDataReader_Type[EXPECTED EXPECTION] The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
The statement has been terminated.

------------------------------ SqlBulkCopySqlDataReader_Variant [type: datetime value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopySqlDataReader_Variant[EXPECTED EXPECTION] The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
The statement has been terminated.

------------------------------ SqlBulkCopyDataTable_Type [type: datetime value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopyDataTable_Type[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ SqlBulkCopyDataTable_Variant [type: datetime value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopyDataTable_Variant[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ SqlBulkCopyDataRow_Type [type: datetime value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopyDataRow_Type[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ SqlBulkCopyDataRow_Variant [type: datetime value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopyDataRow_Variant[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSimpleParameter_Type [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test Simple Parameter [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSimpleParameter_Variant [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test Simple Parameter [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataRecordParameterToTVP_Type [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test SqlDataRecord Parameter To TVP [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test SqlDataRecord Parameter To TVP [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataReaderParameterToTVP_Type [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test SqlDataReader Parameter To TVP [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test SqlDataReader Parameter To TVP [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataReader_TVP_Type [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------
TestSqlDataReader_TVP_Type[EXPECTED EXPECTION] Conversion failed when converting date and/or time from character string.

------------------------------ TestSqlDataReader_TVP_Variant [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------
TestSqlDataReader_TVP_Variant[EXPECTED EXPECTION] Conversion failed when converting date and/or time from character string.

------------------------------ TestSimpleDataReader_Type [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------
TestSimpleDataReader_Type[EXPECTED EXPECTION] Conversion failed when converting date and/or time from character string.

------------------------------ TestSimpleDataReader_Variant [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------
TestSimpleDataReader_Variant[EXPECTED EXPECTION] Conversion failed when converting date and/or time from character string.

------------------------------ SqlBulkCopySqlDataReader_Type [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------
SqlBulkCopySqlDataReader_Type[EXPECTED EXPECTION] Conversion failed when converting date and/or time from character string.

------------------------------ SqlBulkCopySqlDataReader_Variant [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------
SqlBulkCopySqlDataReader_Variant[EXPECTED EXPECTION] Conversion failed when converting date and/or time from character string.

------------------------------ SqlBulkCopyDataTable_Type [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
SqlBulkCopy From Data Table [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ SqlBulkCopyDataTable_Variant [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
SqlBulkCopy From Data Table [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ SqlBulkCopyDataRow_Type [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
SqlBulkCopy From Data Row [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ SqlBulkCopyDataRow_Variant [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
SqlBulkCopy From Data Row [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSimpleParameter_Type [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ TestSimpleParameter_Variant [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 0 : 0

------------------------------ TestSqlDataRecordParameterToTVP_Type [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 0 : 0

------------------------------ TestSqlDataReaderParameterToTVP_Type [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 0 : 0

------------------------------ TestSqlDataReader_TVP_Type [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ TestSqlDataReader_TVP_Variant [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 0 : 0

------------------------------ TestSimpleDataReader_Type [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ TestSimpleDataReader_Variant [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 0 : 0

------------------------------ SqlBulkCopySqlDataReader_Type [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ SqlBulkCopySqlDataReader_Variant [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 0 : 0

------------------------------ SqlBulkCopyDataTable_Type [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ SqlBulkCopyDataTable_Variant [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 0 : 0

------------------------------ SqlBulkCopyDataRow_Type [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 0 : 0

------------------------------ SqlBulkCopyDataRow_Variant [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 0 : 0

------------------------------ TestSimpleParameter_Type [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ TestSimpleParameter_Variant [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ TestSqlDataRecordParameterToTVP_Type [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ TestSqlDataReaderParameterToTVP_Type [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ TestSqlDataReader_TVP_Type [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ TestSqlDataReader_TVP_Variant [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ TestSimpleDataReader_Type [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ TestSimpleDataReader_Variant [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ SqlBulkCopySqlDataReader_Type [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ SqlBulkCopySqlDataReader_Variant [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ SqlBulkCopyDataTable_Type [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ SqlBulkCopyDataTable_Variant [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ SqlBulkCopyDataRow_Type [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ SqlBulkCopyDataRow_Variant [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 3155378975999999999 : 3155378975999999999

------------------------------ TestSimpleParameter_Type [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 630822815999999999 : 630822815999999999

------------------------------ TestSimpleParameter_Variant [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 630822815999999999 : 630822815999999999

------------------------------ TestSqlDataRecordParameterToTVP_Type [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 630822815999999999 : 630822815999999999

------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 630822815999999999 : 630822815999999999

------------------------------ TestSqlDataReaderParameterToTVP_Type [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 630822815999999999 : 630822815999999999

------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 630822815999999999 : 630822815999999999

------------------------------ TestSqlDataReader_TVP_Type [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 630822815999999999 : 630823121999999999

------------------------------ TestSqlDataReader_TVP_Variant [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 630822815999999999 : 630823121999999999

------------------------------ TestSimpleDataReader_Type [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 630822815999999999 : 630823121999999999

------------------------------ TestSimpleDataReader_Variant [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 630822815999999999 : 630823121999999999

------------------------------ SqlBulkCopySqlDataReader_Type [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 630822815999999999 : 630823121999999999

------------------------------ SqlBulkCopySqlDataReader_Variant [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 630822815999999999 : 630823121999999999

------------------------------ SqlBulkCopyDataTable_Type [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 630822815999999999 : 630822815999999999

------------------------------ SqlBulkCopyDataTable_Variant [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 630822815999999999 : 630822815999999999

------------------------------ SqlBulkCopyDataRow_Type [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 630822815999999999 : 630822815999999999

------------------------------ SqlBulkCopyDataRow_Variant [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------
Type        => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset
Base Type   => Expected : Actual == datetimeoffset : datetimeoffset
Value       => Expected : Actual == 630822815999999999 : 630822815999999999

------------------------------ TestSimpleParameter_Type [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 630192959999950000 : 630192959999950000

------------------------------ TestSimpleParameter_Variant [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime
Value       => Expected : Actual == 630192959999950000 : 630192959999970000
Test Simple Parameter [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2]
Test Simple Parameter [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 1/1/1998 11:59:59 PM] [Expected = 1/1/1998 11:59:59 PM]

------------------------------ TestSqlDataRecordParameterToTVP_Type [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 630192959999950000 : 630192959999950000

------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime
Value       => Expected : Actual == 630192959999950000 : 630192959999970000
Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2]
Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 1/1/1998 11:59:59 PM] [Expected = 1/1/1998 11:59:59 PM]

------------------------------ TestSqlDataReaderParameterToTVP_Type [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 630192959999950000 : 630192959999950000

------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime
Value       => Expected : Actual == 630192959999950000 : 630192959999970000
Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2]
Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 1/1/1998 11:59:59 PM] [Expected = 1/1/1998 11:59:59 PM]

------------------------------ TestSqlDataReader_TVP_Type [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 630192959999950000 : 630192959999950000

------------------------------ TestSqlDataReader_TVP_Variant [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime2
Value       => Expected : Actual == 630192959999950000 : 630192959999950000

------------------------------ TestSimpleDataReader_Type [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 630192959999950000 : 630192959999950000

------------------------------ TestSimpleDataReader_Variant [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime2
Value       => Expected : Actual == 630192959999950000 : 630192959999950000

------------------------------ SqlBulkCopySqlDataReader_Type [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 630192959999950000 : 630192959999950000

------------------------------ SqlBulkCopySqlDataReader_Variant [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime2
Value       => Expected : Actual == 630192959999950000 : 630192959999950000

------------------------------ SqlBulkCopyDataTable_Type [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 630192959999950000 : 630192959999950000

------------------------------ SqlBulkCopyDataTable_Variant [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime
Value       => Expected : Actual == 630192959999950000 : 630192959999970000
SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2]
SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 1/1/1998 11:59:59 PM] [Expected = 1/1/1998 11:59:59 PM]

------------------------------ SqlBulkCopyDataRow_Type [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual ==  : 
Value       => Expected : Actual == 630192959999950000 : 630192959999950000

------------------------------ SqlBulkCopyDataRow_Variant [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == datetime2 : datetime
Value       => Expected : Actual == 630192959999950000 : 630192959999970000
SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2]
SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 1/1/1998 11:59:59 PM] [Expected = 1/1/1998 11:59:59 PM]

------------------------------ TestSimpleParameter_Type [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------
TestSimpleParameter_Type>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSimpleParameter_Variant [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------
TestSimpleParameter_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataRecordParameterToTVP_Type [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------
TestSqlDataRecordParameterToTVP_Type>>> EXCEPTION: [System.ArgumentException] Invalid value for this metadata.

------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------
TestSqlDataRecordParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataReaderParameterToTVP_Type [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------
TestSqlDataReaderParameterToTVP_Type>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------
TestSqlDataReaderParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataReader_TVP_Type [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------
TestSqlDataReader_TVP_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
The statement has been terminated.

------------------------------ TestSqlDataReader_TVP_Variant [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------
TestSqlDataReader_TVP_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
The statement has been terminated.

------------------------------ TestSimpleDataReader_Type [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------
TestSimpleDataReader_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
The statement has been terminated.

------------------------------ TestSimpleDataReader_Variant [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------
TestSimpleDataReader_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
The statement has been terminated.

------------------------------ SqlBulkCopySqlDataReader_Type [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopySqlDataReader_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
The statement has been terminated.

------------------------------ SqlBulkCopySqlDataReader_Variant [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopySqlDataReader_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
The statement has been terminated.

------------------------------ SqlBulkCopyDataTable_Type [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopyDataTable_Type>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ SqlBulkCopyDataTable_Variant [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopyDataTable_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ SqlBulkCopyDataRow_Type [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopyDataRow_Type>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ SqlBulkCopyDataRow_Variant [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopyDataRow_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSimpleParameter_Type [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------
TestSimpleParameter_Type>>> EXCEPTION: [System.ArgumentOutOfRangeException] The added or subtracted value results in an un-representable DateTime.
Parameter name: value

------------------------------ TestSimpleParameter_Variant [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == smalldatetime : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test Simple Parameter [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = smalldatetime]
Test Simple Parameter [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataRecordParameterToTVP_Type [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------
TestSqlDataRecordParameterToTVP_Type>>> EXCEPTION: [System.ArgumentException] Invalid value for this metadata.

------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == smalldatetime : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = smalldatetime]
Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataReaderParameterToTVP_Type [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------
TestSqlDataReaderParameterToTVP_Type>>> EXCEPTION: [System.ArgumentOutOfRangeException] The added or subtracted value results in an un-representable DateTime.
Parameter name: value

------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == smalldatetime : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = smalldatetime]
Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataReader_TVP_Type [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------
TestSqlDataReader_TVP_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting character string to smalldatetime data type.

------------------------------ TestSqlDataReader_TVP_Variant [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------
TestSqlDataReader_TVP_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting character string to smalldatetime data type.

------------------------------ TestSimpleDataReader_Type [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------
TestSimpleDataReader_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting character string to smalldatetime data type.

------------------------------ TestSimpleDataReader_Variant [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------
TestSimpleDataReader_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting character string to smalldatetime data type.

------------------------------ SqlBulkCopySqlDataReader_Type [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------
SqlBulkCopySqlDataReader_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting character string to smalldatetime data type.

------------------------------ SqlBulkCopySqlDataReader_Variant [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------
SqlBulkCopySqlDataReader_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting character string to smalldatetime data type.

------------------------------ SqlBulkCopyDataTable_Type [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------
SqlBulkCopyDataTable_Type>>> EXCEPTION: [System.ArgumentOutOfRangeException] The added or subtracted value results in an un-representable DateTime.
Parameter name: value

------------------------------ SqlBulkCopyDataTable_Variant [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == smalldatetime : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = smalldatetime]
SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ SqlBulkCopyDataRow_Type [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------
SqlBulkCopyDataRow_Type>>> EXCEPTION: [System.ArgumentOutOfRangeException] The added or subtracted value results in an un-representable DateTime.
Parameter name: value

------------------------------ SqlBulkCopyDataRow_Variant [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == smalldatetime : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = smalldatetime]
SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSimpleParameter_Type [type: time value:-10675199.02:48:05.4775808] ------------------------------
TestSimpleParameter_Type>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow.  Value '-10675199.02:48:05.4775808' is out of range.  Must be between 00:00:00.0000000 and 23:59:59.9999999.

------------------------------ TestSimpleParameter_Variant [type: time value:-10675199.02:48:05.4775808] ------------------------------
TestSimpleParameter_Variant>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow.  Value '-10675199.02:48:05.4775808' is out of range.  Must be between 00:00:00.0000000 and 23:59:59.9999999.

------------------------------ TestSqlDataRecordParameterToTVP_Type [type: time value:-10675199.02:48:05.4775808] ------------------------------
TestSqlDataRecordParameterToTVP_Type>>> EXCEPTION: [System.ArgumentException] Invalid value for this metadata.

------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: time value:-10675199.02:48:05.4775808] ------------------------------
Type        => Expected : Actual == System.TimeSpan : System.TimeSpan
Base Type   => Expected : Actual == time : time
Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 00:00:00] [Expected = -10675199.02:48:05.4775808]

------------------------------ TestSqlDataReaderParameterToTVP_Type [type: time value:-10675199.02:48:05.4775808] ------------------------------
TestSqlDataReaderParameterToTVP_Type>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow.  Value '-10675199.02:48:05.4775808' is out of range.  Must be between 00:00:00.0000000 and 23:59:59.9999999.

------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: time value:-10675199.02:48:05.4775808] ------------------------------
TestSqlDataReaderParameterToTVP_Variant>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow.  Value '-10675199.02:48:05.4775808' is out of range.  Must be between 00:00:00.0000000 and 23:59:59.9999999.

------------------------------ TestSqlDataReader_TVP_Type [type: time value:-10675199.02:48:05.4775808] ------------------------------
TestSqlDataReader_TVP_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string.

------------------------------ TestSqlDataReader_TVP_Variant [type: time value:-10675199.02:48:05.4775808] ------------------------------
TestSqlDataReader_TVP_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string.

------------------------------ TestSimpleDataReader_Type [type: time value:-10675199.02:48:05.4775808] ------------------------------
TestSimpleDataReader_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string.

------------------------------ TestSimpleDataReader_Variant [type: time value:-10675199.02:48:05.4775808] ------------------------------
TestSimpleDataReader_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string.

------------------------------ SqlBulkCopySqlDataReader_Type [type: time value:-10675199.02:48:05.4775808] ------------------------------
SqlBulkCopySqlDataReader_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string.

------------------------------ SqlBulkCopySqlDataReader_Variant [type: time value:-10675199.02:48:05.4775808] ------------------------------
SqlBulkCopySqlDataReader_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string.

------------------------------ SqlBulkCopyDataTable_Type [type: time value:-10675199.02:48:05.4775808] ------------------------------
SqlBulkCopyDataTable_Type>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow.  Value '-10675199.02:48:05.4775808' is out of range.  Must be between 00:00:00.0000000 and 23:59:59.9999999.

------------------------------ SqlBulkCopyDataTable_Variant [type: time value:-10675199.02:48:05.4775808] ------------------------------
SqlBulkCopyDataTable_Variant>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow.  Value '-10675199.02:48:05.4775808' is out of range.  Must be between 00:00:00.0000000 and 23:59:59.9999999.

------------------------------ SqlBulkCopyDataRow_Type [type: time value:-10675199.02:48:05.4775808] ------------------------------
SqlBulkCopyDataRow_Type>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow.  Value '-10675199.02:48:05.4775808' is out of range.  Must be between 00:00:00.0000000 and 23:59:59.9999999.

------------------------------ SqlBulkCopyDataRow_Variant [type: time value:-10675199.02:48:05.4775808] ------------------------------
SqlBulkCopyDataRow_Variant>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow.  Value '-10675199.02:48:05.4775808' is out of range.  Must be between 00:00:00.0000000 and 23:59:59.9999999.

------------------------------ TestSimpleParameter_Type [type: time value:10675199.02:48:05.4775807] ------------------------------
TestSimpleParameter_Type>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow.  Value '10675199.02:48:05.4775807' is out of range.  Must be between 00:00:00.0000000 and 23:59:59.9999999.

------------------------------ TestSimpleParameter_Variant [type: time value:10675199.02:48:05.4775807] ------------------------------
TestSimpleParameter_Variant>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow.  Value '10675199.02:48:05.4775807' is out of range.  Must be between 00:00:00.0000000 and 23:59:59.9999999.

------------------------------ TestSqlDataRecordParameterToTVP_Type [type: time value:10675199.02:48:05.4775807] ------------------------------
TestSqlDataRecordParameterToTVP_Type>>> EXCEPTION: [System.ArgumentException] Invalid value for this metadata.

------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: time value:10675199.02:48:05.4775807] ------------------------------
TestSqlDataRecordParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Table-valued parameter 0 (""), row 1, column 1: The supplied value is not a valid instance of data type sql_variant. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision.
The statement has been terminated.

------------------------------ TestSqlDataReaderParameterToTVP_Type [type: time value:10675199.02:48:05.4775807] ------------------------------
TestSqlDataReaderParameterToTVP_Type>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow.  Value '10675199.02:48:05.4775807' is out of range.  Must be between 00:00:00.0000000 and 23:59:59.9999999.

------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: time value:10675199.02:48:05.4775807] ------------------------------
TestSqlDataReaderParameterToTVP_Variant>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow.  Value '10675199.02:48:05.4775807' is out of range.  Must be between 00:00:00.0000000 and 23:59:59.9999999.

------------------------------ TestSqlDataReader_TVP_Type [type: time value:10675199.02:48:05.4775807] ------------------------------
TestSqlDataReader_TVP_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string.

------------------------------ TestSqlDataReader_TVP_Variant [type: time value:10675199.02:48:05.4775807] ------------------------------
TestSqlDataReader_TVP_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string.

------------------------------ TestSimpleDataReader_Type [type: time value:10675199.02:48:05.4775807] ------------------------------
TestSimpleDataReader_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string.

------------------------------ TestSimpleDataReader_Variant [type: time value:10675199.02:48:05.4775807] ------------------------------
TestSimpleDataReader_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string.

------------------------------ SqlBulkCopySqlDataReader_Type [type: time value:10675199.02:48:05.4775807] ------------------------------
SqlBulkCopySqlDataReader_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string.

------------------------------ SqlBulkCopySqlDataReader_Variant [type: time value:10675199.02:48:05.4775807] ------------------------------
SqlBulkCopySqlDataReader_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string.

------------------------------ SqlBulkCopyDataTable_Type [type: time value:10675199.02:48:05.4775807] ------------------------------
SqlBulkCopyDataTable_Type>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow.  Value '10675199.02:48:05.4775807' is out of range.  Must be between 00:00:00.0000000 and 23:59:59.9999999.

------------------------------ SqlBulkCopyDataTable_Variant [type: time value:10675199.02:48:05.4775807] ------------------------------
SqlBulkCopyDataTable_Variant>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow.  Value '10675199.02:48:05.4775807' is out of range.  Must be between 00:00:00.0000000 and 23:59:59.9999999.

------------------------------ SqlBulkCopyDataRow_Type [type: time value:10675199.02:48:05.4775807] ------------------------------
SqlBulkCopyDataRow_Type>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow.  Value '10675199.02:48:05.4775807' is out of range.  Must be between 00:00:00.0000000 and 23:59:59.9999999.

------------------------------ SqlBulkCopyDataRow_Variant [type: time value:10675199.02:48:05.4775807] ------------------------------
SqlBulkCopyDataRow_Variant>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow.  Value '10675199.02:48:05.4775807' is out of range.  Must be between 00:00:00.0000000 and 23:59:59.9999999.

------------------------------ TestSimpleParameter_Type [type: time value:1/1/0001 00:00:00] ------------------------------
TestSimpleParameter_Type>>> EXCEPTION: [System.InvalidCastException] Failed to convert parameter value from a DateTime to a TimeSpan.

------------------------------ TestSimpleParameter_Variant [type: time value:1/1/0001 00:00:00] ------------------------------
TestSimpleParameter_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataRecordParameterToTVP_Type [type: time value:1/1/0001 00:00:00] ------------------------------
TestSqlDataRecordParameterToTVP_Type>>> EXCEPTION: [System.InvalidCastException] Specified cast is not valid.

------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: time value:1/1/0001 00:00:00] ------------------------------
TestSqlDataRecordParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataReaderParameterToTVP_Type [type: time value:1/1/0001 00:00:00] ------------------------------
TestSqlDataReaderParameterToTVP_Type>>> EXCEPTION: [System.InvalidCastException] Failed to convert parameter value from a DateTime to a TimeSpan.

------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: time value:1/1/0001 00:00:00] ------------------------------
TestSqlDataReaderParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSqlDataReader_TVP_Type [type: time value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.TimeSpan
Base Type   => Expected : Actual ==  : 
TestSqlDataReader_TVP_Type>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'.

------------------------------ TestSqlDataReader_TVP_Variant [type: time value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.TimeSpan
Base Type   => Expected : Actual == time : time
TestSqlDataReader_TVP_Variant>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'.

------------------------------ TestSimpleDataReader_Type [type: time value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.TimeSpan
Base Type   => Expected : Actual ==  : 
TestSimpleDataReader_Type>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'.

------------------------------ TestSimpleDataReader_Variant [type: time value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.TimeSpan
Base Type   => Expected : Actual == time : time
TestSimpleDataReader_Variant>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'.

------------------------------ SqlBulkCopySqlDataReader_Type [type: time value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.TimeSpan
Base Type   => Expected : Actual ==  : 
SqlBulkCopySqlDataReader_Type>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'.

------------------------------ SqlBulkCopySqlDataReader_Variant [type: time value:1/1/0001 00:00:00] ------------------------------
Type        => Expected : Actual == System.DateTime : System.TimeSpan
Base Type   => Expected : Actual == time : time
SqlBulkCopySqlDataReader_Variant>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'.

------------------------------ SqlBulkCopyDataTable_Type [type: time value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopyDataTable_Type>>> EXCEPTION: [System.InvalidOperationException] The given value of type DateTime from the data source cannot be converted to type time of the specified target column.

------------------------------ SqlBulkCopyDataTable_Variant [type: time value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopyDataTable_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ SqlBulkCopyDataRow_Type [type: time value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopyDataRow_Type>>> EXCEPTION: [System.InvalidOperationException] The given value of type DateTime from the data source cannot be converted to type time of the specified target column.

------------------------------ SqlBulkCopyDataRow_Variant [type: time value:1/1/0001 00:00:00] ------------------------------
SqlBulkCopyDataRow_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

------------------------------ TestSimpleParameter_Type [type: time value:12/31/9999 23:59:59.9999999] ------------------------------
TestSimpleParameter_Type>>> EXCEPTION: [System.InvalidCastException] Failed to convert parameter value from a DateTime to a TimeSpan.

------------------------------ TestSimpleParameter_Variant [type: time value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == time : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test Simple Parameter [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = time]
Test Simple Parameter [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataRecordParameterToTVP_Type [type: time value:12/31/9999 23:59:59.9999999] ------------------------------
TestSqlDataRecordParameterToTVP_Type>>> EXCEPTION: [System.InvalidCastException] Specified cast is not valid.

------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: time value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == time : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = time]
Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataReaderParameterToTVP_Type [type: time value:12/31/9999 23:59:59.9999999] ------------------------------
TestSqlDataReaderParameterToTVP_Type>>> EXCEPTION: [System.InvalidCastException] Failed to convert parameter value from a DateTime to a TimeSpan.

------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: time value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == time : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = time]
Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ TestSqlDataReader_TVP_Type [type: time value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.TimeSpan
Base Type   => Expected : Actual ==  : 
TestSqlDataReader_TVP_Type>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'.

------------------------------ TestSqlDataReader_TVP_Variant [type: time value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.TimeSpan
Base Type   => Expected : Actual == time : time
TestSqlDataReader_TVP_Variant>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'.

------------------------------ TestSimpleDataReader_Type [type: time value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.TimeSpan
Base Type   => Expected : Actual ==  : 
TestSimpleDataReader_Type>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'.

------------------------------ TestSimpleDataReader_Variant [type: time value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.TimeSpan
Base Type   => Expected : Actual == time : time
TestSimpleDataReader_Variant>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'.

------------------------------ SqlBulkCopySqlDataReader_Type [type: time value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.TimeSpan
Base Type   => Expected : Actual ==  : 
SqlBulkCopySqlDataReader_Type>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'.

------------------------------ SqlBulkCopySqlDataReader_Variant [type: time value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.TimeSpan
Base Type   => Expected : Actual == time : time
SqlBulkCopySqlDataReader_Variant>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'.

------------------------------ SqlBulkCopyDataTable_Type [type: time value:12/31/9999 23:59:59.9999999] ------------------------------
SqlBulkCopyDataTable_Type>>> EXCEPTION: [System.InvalidOperationException] The given value of type DateTime from the data source cannot be converted to type time of the specified target column.

------------------------------ SqlBulkCopyDataTable_Variant [type: time value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == time : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = time]
SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]

------------------------------ SqlBulkCopyDataRow_Type [type: time value:12/31/9999 23:59:59.9999999] ------------------------------
SqlBulkCopyDataRow_Type>>> EXCEPTION: [System.InvalidOperationException] The given value of type DateTime from the data source cannot be converted to type time of the specified target column.

------------------------------ SqlBulkCopyDataRow_Variant [type: time value:12/31/9999 23:59:59.9999999] ------------------------------
Type        => Expected : Actual == System.DateTime : System.DateTime
Base Type   => Expected : Actual == time : datetime
Value       => Expected : Actual == 3155378975999999999 : 3155378975999970000
SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = time]
SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM]
Starting 'OutputParameter' tests
Test setting output SqlParameter to an invalid value
Done
